Cloud Premigration Advisor Tool (CPAT) Analyzes Databases for Suitability of Cloud Migration
(Doc ID 2758371.1)
Last updated on SEPTEMBER 18, 2024
Applies to:
Oracle Autonomous Database - Shared - Version N/A and laterOracle Autonomous Database - Dedicated - Version N/A and later
Autonomous Transaction Processing - Version NA and later
Autonomous Database Dedicated - Version NA and later
Autonomous Database Serverless - Version N/A and later
Information in this document applies to any platform.
Goal
The Cloud Premigration Advisor Tool (CPAT) helps you evaluate an existing Oracle database for compatibility with Autonomous Database (ADB.) Using CPAT before migrating to ADB makes assessing your source database easier and faster! CPAT removes much of the legwork of identifying potential user actions, prioritizing their importance, and suggesting resolutions. Oracle recommends using CPAT to accelerate your migration to Oracle Cloud.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Cloud Premigration Advisor Tool (CPAT) |
| Downloading and Extracting CPAT from the Zip File |
| Supported Database Versions |
| Recent Changes to CPAT |
| Basic Usage Notes and Requirements |
| Running CPAT |
| Required and Optional Environment Variables |
| Required Command Line Switches |
| Required Privileges |
| Best Practices using Optional Command Line Switches |
| Fetch Target Instance Properties for Use in Source Instance Analysis |
| Limit the Analysis Done by CPAT Appropriately |
| Generate the JSON Report Even if You Do Not Need It and Always Save the Log File |
| Command Options that Help with Generating "What If" Scenarios |
| Limiting the Amount of Data in Reports |
| Invoking CPAT Using a Parameter File |
| Additional Usage Notes |
| Target Cloud Values |
| Automatic Detection of Target Cloud |
| Migration Methods |
| Connection Strings |
| Analyzing Multiple PDBs in a CDB |
| Generating "Fixups" for Checks That Do Not Pass |
| Scope of CPAT Checks |
| Full vs Schema "Mode" |
| FULL mode |
| SCHEMA mode |
| Controlling CPAT's Mode |
| Additional Mode Notes |
| Interpreting CPAT Report Data |
| Relevant Objects Included for Checks in CPAT Reports |
| Why are Checks sometimes marked as "skipped" |
| Checking for a Updated Version of CPAT |
| CPAT Integration with Other Oracle Products |
| Updating CPAT in a Zero Downtime Migration Home |
| Using CPAT with Other Tooling or Scripted Processes |
| CPAT Shell Script Exit Codes |
| Security Notes |
| Summary |
| References |